Running the Financial Statements report

Use this report to create a set of consolidated financial statements for the selected scenario(s).

This report includes the following data:

  • Credit Profile – Common financial metrics used for analysis by rating agencies
    • Financial Summary - Selected profitability and capital metrics
    • Profitability - Annual Operating Margin, Operating EBIDA Margin, and Excess Margin grid and graph, compared to selected rating median
    • Debt Position - Annual debt service coverage, debt to capitalization, and debt to cash flow grid and graph compared to selected rating median
    • Liquidity - Annual cash to debt, days cash, and days in AR grid and graph compared to selected rating median

    • Other Financials – Average age of plant, capital spending ratio, and compensation ratio grid and graph compared to selected rating median

  • Capital Position Analysis – Sources and uses of cash analysis for selected number of years. Allows entry of other additional sources and uses of cash as well as bond funds and displays cash flow requirements and historical cash flow

  • Capital Position Scenarios - Annual cash flow requirements for incremental days cash on hand values with the option to change days cash on hand values and increment baseline cash values

  • Capital Capacity – Estimated debt capacity, long-term debt, existing cash, minimum cash target, net cash position, and net capital capacity grid and graph

To run the Financial Statements report:

  1. In the Fin Plan Admin or Fin Plan task pane, in the Financial Planning Reports section, click Financial Analysis, and double-click Financial Statements.

    NOTE: There are two Financial Statements reports listed in the task pane. These reports are identical.

  2. Refresh the data in the report by doing one of the following:

    • In the Admin ribbon tab, in the Workbook Options group, click Refresh Data.

    • Press F9.

  3. In the Refresh Variables dialog, select the following, and click OK:

    NOTE: To return all results, leave the selections blank, and click OK.

    Option Description
    Select Rating Agency Median

    Select the Rating Agency Median to include in the report.

    NOTE: By default, the system uses the rating agency median selected in the Setup driver.
    Filter by select group of scenarios?

    Do one of the following:

    • To filter the report by the specified group the scenario belongs to, select Yes.
    • To not filter the report by group, select No.
    Select SCENARIO

    Select one or more scenarios.
    No. of Projection Years Select the number of projected years.
    Select Model(s) (optional) Select one or more models.
  4. At the top of the report, in the Financial Planning Year cell, select the planning year data to view.

  5. To save the report, in the Main ribbon tab, click Save.